home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Freelog Special Freeware 31
/
FreelogHS31.iso
/
ArgentCompta
/
FASTCAISSE
/
Setup FASTCAISSE.exe
/
{app}
/
A faire38.sql
< prev
next >
Wrap
Text File
|
2003-11-03
|
2KB
|
53 lines
drop PROCEDURE "RCHCODE";
drop PROCEDURE "RCHCODEBARRE";
DROP PROCEDURE "RCHCODEMAG";
DROP PROCEDURE "EFFACE_3";
ALTER TABLE "ARTFOUR" DROP AJOUR;
ALTER TABLE "ARTICLES" DROP AJOUR;
ALTER TABLE "CHAINES" DROP AJOUR;
ALTER TABLE "CLIENTS" DROP AJOUR;
ALTER TABLE "ETATS" DROP AJOUR;
ALTER TABLE "FOURNISSEURS" DROP AJOUR;
ALTER TABLE "MACROS" DROP AJOUR;
ALTER TABLE "PIECES" DROP AJOUR;
ALTER TABLE "RAYONS" DROP AJOUR;
ALTER TABLE "SOCIETES" DROP AJOUR;
ALTER TABLE "VENDEURS" DROP AJOUR;
ALTER TABLE "VENDEURS" ALTER "PASSWORD" TO "MOTDEPASSE";
CREATE PROCEDURE "VALEUR_STOCK"
RETURNS
(
"S_INDEX" INTEGER,
"S_RAYON" SMALLINT,
"S_DISPO" DECIMAL(12,2),
"S_INVENTAIRE" DECIMAL(12,2)
)
AS
DECLARE variable P1 DECIMAL(12,2);
DECLARE variable Q1 DECIMAL(6,2);
DECLARE variable Q2 DECIMAL(6,2);
DECLARE VARIABLE N1 INTEGER;
DECLARE VARIABLE N2 INTEGER;
BEGIN
For SELECT INDX,RAYON,PMPA,DISPO,INVENTAIRE,DERFOUR FROM ARTICLES INTO :S_INDEX,S_RAYON,:P1,:Q1,:Q2,:N1 do
begin
IF (P1 IS NULL) THEN
BEGIN
SELECT MIN(DPA) FROM ARTFOUR WHERE INDXART=:S_INDEX AND CODEFOUR=:N1 INTO :P1;
IF (P1 IS NULL) THEN
BEGIN
SELECT MIN(DPA) FROM ARTFOUR WHERE INDXART=:S_INDEX INTO :P1;
END
END
S_DISPO = P1 * Q1;
IF (Q2 IS NULL) THEN S_INVENTAIRE = S_DISPO; ELSE S_INVENTAIRE = P1 * (Q1+Q2);
SUSPEND;
end
END
;
ALTER TABLE ARTICLES ADD PKEYR COMPUTED BY (RAYON*10000+FAMILLE*100+SSFAMILLE);
SET GENERATOR VERSION_BASE TO 38;